﻿CREATE TABLE [dbo].[CiDbLinkDefine] (
    [Id]           INT            IDENTITY (1, 1) NOT NULL,
    [LinkName]     NVARCHAR (50)  NOT NULL,
    [LinkType]     NVARCHAR (20)  NOT NULL,
    [LinkData]     VARCHAR (MAX)  NOT NULL,
    [DeleteMark]   INT            CONSTRAINT [DF__CiDbLinkD__Delet__7F60ED59] DEFAULT ((0)) NOT NULL,
    [SortCode]     INT            NULL,
    [Enabled]      INT            CONSTRAINT [DF__CiDbLinkD__Enabl__00551192] DEFAULT ((1)) NOT NULL,
    [Description]  NVARCHAR (500) NULL,
    [CreateOn]     DATETIME       CONSTRAINT [DF__CiDbLinkD__Creat__014935CB] DEFAULT (getdate()) NOT NULL,
    [CreateUserID] INT            NULL,
    [CreateBy]     NVARCHAR (50)  NULL,
    [ModifiedOn]   DATETIME       NULL,
    [ModifyUserId] INT            NULL,
    [ModifiedBy]   NVARCHAR (50)  NULL,
    CONSTRAINT [PK_CiDbLinkDefine] PRIMARY KEY CLUSTERED ([Id] ASC)
);

